Excel Export

Hi,

I need help. I must code an Excel Export from Doors. The thing is that I must export automatically all modules within a folder in Doors. Doors comes by default with a Excel-export script.

Does it make sense to modify this script? Or is it better to design a new script?


tobi_mehrl - Wed Jun 03 04:02:21 EDT 2015

Re: Excel Export
woodpryan - Wed Jun 03 12:07:07 EDT 2015

You are best creating something new and taking the functions you need from the pre-existing DOORS MS Excel export script. Take the parts that actually open MS Excel, and write to a cell, and write some code to call the necessary functions for each Module.

Re: Excel Export
llandale - Wed Jun 03 15:58:37 EDT 2015

woodpryan - Wed Jun 03 12:07:07 EDT 2015

You are best creating something new and taking the functions you need from the pre-existing DOORS MS Excel export script. Take the parts that actually open MS Excel, and write to a cell, and write some code to call the necessary functions for each Module.

I think MM resolved this some time ago with features such as these:

  • use the entire export excel script as-is
  • override the "show(DB)" perm with a "realize(DB)" call instead
  • write an eval_ code that opens a single module, and #includes the script in the (eval_) to program context.  After the #include, issue a call to the main callback function.
  • Write a DXL that loops through all modules in the folder and below and eval_s as above.

The trick is sending the module name, or even the open module Handle, to the eval_ code.  That involves addr_ int (addr_) voodoo.

-Louie